Validate Group Rooming List

Stay is enhanced to validate the details provided by the users in the Excel file used for importing the rooming list for groups. Previously, the rooming list was imported with minimal validation. This resulted in the creation of staged data for groups with incompatible values.

This enhancement validates the details provided for import with the format compatible for each field. This helps in the creation of staged data with appropriate values that can be used for booking reservations for groups.

Validation of Rooming List

The following fields and columns in the Excel file are validated during the import of the rooming list (Groups ➜ Reservations ➜ Staging ➜ Import Rooming List):

Column	Description
Title	If the entered title is in an invalid format, the following message is displayed: Invalid title: <entered value>.
First_Name_Field	This field supports letters, numbers, and special characters and does not impose restrictions on the number of characters to be entered. When this field is left empty, the following message is displayed: First name is empty.
Last_Name_Field	This field supports letters, numbers, and special characters and does not impose restrictions on the number of characters to be entered. When this field is left empty, the following message is displayed: Last name is empty.
Arrival Date	This field supports only numeric characters, and the date must be entered in the format supported by the property. For example, when the property uses the mm/dd/yyyy format and when a user enters a number greater than 12 for month, the following message is displayed: Invalid arrival date. When the arrival date is prior to a group’s arrival shoulder date, the following message is displayed: The reservation arrival date should not be before <arrival/arrival shoulder date of the group>. When the arrival date is beyond the group’s departure shoulder date, the following message is displayed: The reservation arrival date should not be after <departure/departure shoulder date of the group>.
Departure Date	This field supports only numeric characters, and the date must be entered in the format supported by the property. For example, when the property uses the mm/dd/yyyy format and when a user enters a number greater than 12 for month, the following message is displayed: Invalid arrival date. When the departure date is beyond the group’s departure shoulder date, the following message is displayed: The reservation departure date should not be after <departure/departure shoulder date of the group>. When the departure date is the same or prior to a group’s arrival shoulder date, the following message is displayed: The reservation departure date should not be before <arrival/arrival shoulder date of the group>. When the arrival and the departure dates are the same, the following message is displayed: Arrival date cannot be equal to the group end date.
Room Type	When the room type code entered does not exist in Stay, the file is imported, and the following message is displayed: Invalid room type: <entered value>.
Source Code	When an invalid source code is entered, the file is imported, and the following message is displayed: Invalid source code: <entered value>.
Market Segment	When an invalid market segment code is entered, the file is imported, and the following message is displayed: Invalid segment code: <entered value>.
Guest Type	When an invalid guest type code is entered, the file is imported, and the following message is displayed: Invalid guest type: <entered value>.
Loyalty Programs	When an invalid loyalty program name is entered, the file is imported, and the following message is displayed: Invalid loyalty program(s).
Override Room Rate	When users enter a negative value for the room rate, the file will be imported, and the following message is displayed: Override room rate cannot be negative value. When decimal values are entered, the following message is displayed: Character is neither a decimal digit number, decimal point, nor empty notation exponential mark.
Rate Change Comment	When users do not enter a value for the Override Room Rate column but enter a value in the Rate Change Comment column, the file is imported, and the following message is displayed: Override room rate is required for rate change comment. When a value is entered in the Override Room Rate column, but the Rate Change Comment column is left blank, the following message is displayed: Rate change comment is required.
Comp Category	When an invalid comp category is entered, the file is imported, and the following message is displayed: Invalid comp category: <entered value>.
Comp Certificate	When users enter an invalid comp certificate details with non-alphanumeric characters, the file is imported, and the following message is displayed: Certificate should be alphanumeric.
Country	When users enter the country name in invalid format, the following message is displayed: Invalid country: <entered value>.
State	When users enter the state name in invalid format, the following message is displayed: Invalid state code: <entered value>.
Adult & Children	When the count of adult/children entered is greater than the count of the maximum guest count allowed for the room type, the following message is displayed: Maximum count exceeded.

When users import the Excel file in the Upload XLS or XLSX or CSV section of the Import Rooming List pop-up screen and click Next, they are navigated to the Rooming list field mapping section where the details entered in the file are mapped against the corresponding fields.

Users must select the preferred values for the fields and click Preview. When clicked, the Group Reservation Import pop-up screen appears that displays the details of the fields processed:

Once the details are processed, users are navigated to the Previewing the imported list section where the entered details are validated. The fields with incorrect values are highlighted in red. When users hover over the field, the reason for the highlight is displayed.

Users can modify the values of the highlighted fields in this section. When there is more than one record, users can modify the field values for multiple records using the Bulk Edit option. When the value of a field is modified, users must validate the modified value using the Validate option. The values of the fields along with the messages can be exported as an .xlsx file using the Export option. Users can also continue to import files with incorrect values.

When users click Save, the Confirmation pop-up screen appears that prompts users to confirm if the import must be completed. When users click Yes, the import will be completed successfully, and the values will be populated against the corresponding fields in the Staging section of the Reservations tab.

Select/Deselect Columns from the Column Settings Screen

When users access the Column Settings screen (Groups ➜ Reservations ➜ Column Settings), all the columns imported from the Excel file will be displayed. The columns for which values were validated in the Previewing the imported list section of the Import Rooming List pop-up screen cannot be deselected. These columns will be disabled for selection.

System Changes

To support this enhancement, the following sections have been added to the Import Rooming List pop-up screen (Groups ➜ Reservations ➜ Staging ➜ Import Rooming List):

Upload XLS or XLSX or CSV
Rooming list field mapping
Previewing the imported list